﻿ IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'tb_Vendor_InspVisit_XmissionStructures_Results') 
AND name = N'IDX_tb_Vendor_InspVisit_XmissionStructures_Results_PoleFk')
	DROP INDEX IDX_tb_Vendor_InspVisit_XmissionStructures_Results_PoleFk ON tb_Vendor_InspVisit_XmissionStructures_Results WITH ( ONLINE = OFF )

CREATE NONCLUSTERED INDEX IDX_tb_Vendor_InspVisit_XmissionStructures_Results_PoleFk ON tb_Vendor_InspVisit_XmissionStructures_Results
(
	Vendor_InspVisit_XMissionStructure_PoleFk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 